<?php 
if(!isset($_SESSION)) 
{ 
	session_start(); 
}

$_SESSION['action'] = "library";

if(!isset($_REQUEST['page'])){
$list["Tile"]="DESC";
$list["Timecreate"]="DESC";
$list["FullName"]="DESC";
$list["IDApproveDoc"]="DESC";
$str="Timecreate";
$_SESSION['sortn']=$str;
$_SESSION['sort']=$list;

}else{
	$str=$_SESSION['sortn'];
	$list=$_SESSION['sort'];
}
	
if(array_key_exists("page",$_GET))
	$page  = $_GET['page'];
else
	$page = 1;
	
	
$sql="(SELECT a.IDEmployee,a.Tile,a.IDTypeDoc,a.IDApproveDoc,DATE_FORMAT(a.Timecreate, '%Y-%m-%d') as Timecreate,employee.FullName,a.IDGroupApprove,a.SumMoney,a.isView as is_view FROM approvedoc a,employee 
WHERE a.IDLabel=".$_REQUEST['libraryid']." and a.IDEmployee=employee.IDEmployee )  
union all
(SELECT a.IDEmployee,a.Tile,a.IDTypeDoc,a.IDApproveDoc,DATE_FORMAT(a.Timecreate, '%Y-%m-%d') as Timecreate,employee.FullName,a.IDGroupApprove,a.SumMoney,la.isView as is_view FROM listapprove la,approvedoc a, employee   
WHERE la.IDLabel=".$_REQUEST['libraryid']." AND a.IDGroupApprove=la.IDGroupApprove AND la.IDEmployee='".$id_employee."' and employee.IDEmployee=a.IDEmployee) 
union all
(SELECT a.IDEmployee,a.Tile,a.IDTypeDoc,a.IDApproveDoc,DATE_FORMAT(a.Timecreate, '%Y-%m-%d') as Timecreate,employee.FullName,a.IDGroupApprove,a.SumMoney,lr.id_status as is_view FROM list_reference lr,approvedoc a, employee  
WHERE lr.IDLabel=".$_REQUEST['libraryid']." AND a.IDGroupApprove=lr.id_group AND lr.id_employee='".$id_employee."' and employee.IDEmployee=a.IDEmployee)";

$query= mysql_query($sql." ORDER BY ".$str." ".$list[$str]);
$number_of_page = ceil ( mysql_num_rows( $query ) / $rows_per_page ); 
    
?>
<script type="text/javascript">
function sort(libraryname,libraryid,page,str,co)
{
	if (window.XMLHttpRequest){// code for IE7+, Firefox, Chrome, Opera, Safari
		xmlhttp=new XMLHttpRequest();
	}else{// code for IE6, IE5
		xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
	}
	xmlhttp.onreadystatechange=function(){
										  if (xmlhttp.readyState==4 && xmlhttp.status==200){
										    	document.getElementById("content").innerHTML=xmlhttp.responseText;
										  }
									  }
	xmlhttp.open("GET","ajax/list/sort_li.php?libraryid="+libraryid+"&libraryname="+libraryname+"&page="+page+"&str="+str+"&co="+co,true);
	xmlhttp.send();
}

</script>
<div class="nav_top">
       		<div class="nav_tit"><?php echo $l_e_approval;?></div>     
            <div class="rehome"><a href="mainPhone.php"><?php echo $l_menu?></a></div>       
       	</div>
<div class="main_content">
   <h3 class="atitle"><a href="menu.php?append=libraryDocument"><?=$l_li_document ?></a> &rarr; <?=$_REQUEST['liname']; ?></h3>
   <div style="width:100%" id="content" >
   <table class="tcontent" cellpadding="5" cellspacing="0">
        <tr style="background-color:#EEE;"  >
			<td width="3%"><input type="checkbox" name="chonhet" id="chonhet" onclick="clickChonHet(this);" /></td>
			<td width="3%"><?=$l_no?></td>
			<!--td><a onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',<?=$page?>,'IDApproveDoc','1','<?=$search?>','<?=$tile?>','<?=$fromdate?>','<?=$todate?>','<?=$IDEmployeeSend?>')">ID</a></td-->
			<td width="20%"><?=$l_document_form?></td>
			
			
			<td width="40%"><a style="cursor:pointer;" onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',<?=$page?>,'Tile','1')"><?=$l_title?></a></td>
			<td width="10%"><a style="cursor:pointer;" onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',<?=$page?>,'FullName','1')"><?=$l_writer?></a></td>
			<td width="10%"><a style="cursor:pointer;" onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',<?=$page?>,'Timecreate','1')"><?=$l_created_date?></a></td>
			
		</tr>
      <?php
												
											   $i = 0; 
											    while ($row=mysql_fetch_array($query)){
											    	if ( $i >= $page_start  ) 
													{ 
												    	if($row[IDTypeDoc]==7)$document = $l_vacation_form;
												    	else if($row[IDTypeDoc]==12)$document = $l_assignment_report;
												    	else if($row[IDTypeDoc]==13)$document = $l_purchase_order;
												    	else if($row[IDTypeDoc]==14)$document = $l_daily_report;
												    	else if($row[IDTypeDoc]==15)$document = $l_business_trip_report;
												    	else if($row[IDTypeDoc]==16)$document = $l_weekly_report;
												    	else if($row[IDTypeDoc]==17)$document = $l_susqence_payment_request;
												    
												?>
													<tr bgcolor="#ffffff" class="highlighter">
														<td><input type="checkbox"  name="chon" value="<?php echo $row[IDApproveDoc].'-'.$row[IDGroupApprove].'-'.$row[IDEmployee];?>" /></td>
														<td width="3%" align="center"><?=($i+1)?></td>
														<!--td width="12%" ><a href="library.php?id=<?=$row[IDApproveDoc]?>&type= <?=$row[IDTypeDoc]?>"><?php echo $row[IDApproveDoc];?></a></td-->
														<td width="17%" align="left"><div  align="left" ><?php echo $document;?></div></td>
														<td width="30%" align="left">
															<div  align="left" >
																<a style="color:blue;" href="view.php?action=<?=$_SESSION['action']?>&id=<?=$row[IDApproveDoc]?>&type= <?=$row[IDTypeDoc]?>&page=<?=$page?>"><?=$row[Tile]?> </a>
																<p style="float:right">
															<?php 
																if($row[IDTypeDoc]==13 || $row[IDTypeDoc]==15 || $row[IDTypeDoc]==17){
																	if($row[SumMoney]>0){
																		echo " [ ".number_format($row[SumMoney])." ]";
																	}else{
																		if($row[IDTypeDoc]==15 || $row[IDTypeDoc]==13){
																			$s1="select sum(buying_document.total) as tongtien from approvedoc,buying_document where approvedoc.IDApproveDoc=buying_document.document_id and approvedoc.IDApproveDoc='".$row[IDApproveDoc]."' GROUP BY approvedoc.IDApproveDoc";
																			$k1=mysql_query($s1);
																			while ($r1=mysql_fetch_array($k1)){
																				if($r1[tongtien]>0){
																					echo " [ ".number_format($r1[tongtien])." ]";
																				}
																			}
																		}else if($row[IDTypeDoc]==17){
																			$s1="select sum(ap_advance.money) as tongtien from approvedoc,ap_advance where approvedoc.IDApproveDoc=ap_advance.document_id and approvedoc.IDApproveDoc='".$row[IDApproveDoc]."' GROUP BY approvedoc.IDApproveDoc";
																			$k1=mysql_query($s1);
																			while ($r1=mysql_fetch_array($k1)){
																				if($r1[tongtien]>0){
																					echo " [ ".number_format($r1[tongtien])." ]";
																				}
																			}
																		}
																	}
																}
															?>
															</p>
															</div>
															
														</td>
														<td width="15%"><?=$row[FullName]?></td>
														<td width="20%"><?=$row[Timecreate]?></td>
														
													</tr>
												<?php 	}
												
													$i++; 
													
													if ($i >= $page_end) 
													{ 
													break; 
													} 
												}
												
													
												?>
        
				
				<?php if ( $number_of_page > 1 ) 
				{ 
					?>
					<tr>
						<td colspan="7" class="bt_td_main">
							<span style="background:#fff; padding:1px; display: inline-block;">
					<?php 
					if ($page==1)
						$p=2;
					else if ($page==$number_of_page)
						$p=$number_of_page-1;
					else $p=$page;
					if($page!=1){?>
						<a onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',1,'<?=$str?>',0)" ><span class='button_next'><?php echo "<<";?></span> </a>
						<a onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',<?=($page-1)?>,'<?=$str?>',0)" ><span class='button_next'><?php echo "<";?></span> </a>
					<?php  }
					else{
						//echo "<span class='button_next'><<<</span>"; 
						//echo "<span class='button_next'><<</span>";
					}
					for ( $i = $p-1; $i <= $p+1; $i++ ) {	
							if ($i<=$number_of_page && $i>0)
							
								if ($i==$page){
									echo "<span class='button_next' style='color:#324fa2;font-weight:bold;'>".$i."</span>"; 
								}else{
								?>
									<a onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',<?=$i?>,'<?=$str?>',0)" ><span class="button_next" style="color: #508e21;">
									<?php 
									echo $i;
									?>
									</span> </a>
									<?php 
								}
							?>
						
					<?php 
							}
						
						if($page!=$number_of_page){ ?>
							<a onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',<?=($page+1)?>,'<?=$str?>',0)"><span class='button_next'><?php echo ">";?></span> </a>
							<a onclick="sort('<?=$_REQUEST['liname']?>','<?=$_REQUEST['libraryid']?>',<?=($number_of_page)?>,'<?=$str?>',0)" ><span class='button_next'><?php echo ">>";?></span> </a>
						<?php }
						else{
							//echo "<span class='button_next'>>></span> ";
							//echo "<span class='button_next'>>>></span> ";
						}
						?>
						</span>
					</td>
				</tr>
						<?php 
					}
				
					
					?>
																		
			
	</table>
    </div>
</div>